SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59321: DI_ETL_Geo_prod_purge_job does not purge DI_MON.UNBALANCED_*_HIER tables

DetailsAboutRate It

The SAS® Merchandise Intelligence DI_ETL_Geo_purge_job does not use the DI_MON.UNBALANCED_PRODUCT_HIER or DI_MON.UNBALANCED_GEOGRAPHY_HIER tables.

This issue might mean that items that should be purged are not purged. For example, if there are 7 levels in a product hierarchy and a level 5 product is loaded into the DIDM_STG.STG_GEO_PROD_PURGE_LIST, then all level 6 and level 7 children of that product should be purged. However, if there are level 6 children in the DI_MON.UNBALANCED_PRODUCT_HIER table, then they are not purged.

This issue might also cause there to be nodes in the DI_MON.UNBALANCED_PRODUCT_HIER or DI_MON.UNBALANCED_GEOGRAPHY_HIER tables for which there are no corresponding nodes in the DI_DM.PRODUCT_DM or DI_DM.GEOGRAPHY_DM tables. For example, if there are 7 levels in a product hierarchy and a level 6 product that does not have any level 7 children is loaded into the DIDM_STG.GEO_PROD_PURGE_LIST, then the product is removed from DI_DM.PRODUCT_DM and other tables, but it is not removed from DI_MON.UNBALANCED_PRODUCT_HIER.

Please contact Technical Support for assistance with this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Regular Price OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Retail ForecastingMicrosoft® Windows® for x645.2_M49.3 TS1M2
Linux for x645.2_M49.3 TS1M2
SAS SystemSAS Size ProfilingMicrosoft® Windows® for x643.2_M43.419.3 TS1M29.4 TS1M4
64-bit Enabled AIX3.2_M43.419.3 TS1M29.4 TS1M4
Linux for x643.2_M43.419.3 TS1M29.4 TS1M4
SAS SystemSAS Pack OptimizationMicrosoft® Windows® for x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8 Enterprise 32-bit3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8 Enterprise x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8 Pro 32-bit3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8 Pro x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8.1 Enterprise x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows 8.1 Pro x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2003 Datacenter Edition3.2_M49.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition3.2_M49.3 TS1M2
Microsoft Windows Server 2003 Standard Edition3.2_M49.3 TS1M2
Microsoft Windows Server 2003 for x643.2_M49.3 TS1M2
Microsoft Windows Server 20083.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2008 R23.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2008 for x643.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2012 Datacenter3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2012 R2 Std3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows Server 2012 Std3.2_M43.419.3 TS1M29.4 TS1M4
Microsoft Windows XP Professional3.2_M49.3 TS1M2
Windows 7 Enterprise 32 bit3.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Enterprise x643.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Home Premium 32 bit3.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Home Premium x643.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Professional 32 bit3.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Professional x643.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Ultimate 32 bit3.2_M43.419.3 TS1M29.4 TS1M4
Windows 7 Ultimate x643.2_M43.419.3 TS1M29.4 TS1M4
Windows Vista3.2_M49.3 TS1M2
Windows Vista for x643.2_M49.3 TS1M2
64-bit Enabled AIX3.2_M43.419.3 TS1M29.4 TS1M4
Linux for x643.2_M43.419.3 TS1M29.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.